hive -e "
use credit;
set hive.exec.mode.local.auto=true;


insert overwrite table dw_cust_info
select
    regexp_replace(c.cust_id, '[^0-9]+','') cust_id,
    regexp_replace(c.cust_name, '[^\\u4e00-\\u9fa5]+','') cust_name,
    product_code,
    txt_amt,
    addrno,
    age,
    dt,
    current_date
from ods_cust_info c;

insert overwrite table dw_addr_info
select distinct * from ods_addr_info;

insert overwrite table dw_product_info
select distinct * from ods_product_info;
"
